{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# amap.com 搜索 api/search：集成一步到位\n",
    "- A. 步步学的代码见\n",
    " [research_amap_search_NewMedia_cities_learning.ipynb](research_amap_search_NewMedia_cities_learning.ipynb)\n",
    "- C. 包成函数的代码见\n",
    " [research_amap_search_NewMedia_cities_function.ipynb](research_amap_search_NewMedia_cities_function.ipynb)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 务必自己练习集成代码及拆解代码说明的能力"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests #用於API HTTP requests\n",
    "import pandas as pd\n",
    "\n",
    "parameters = {'key': '你自己申請到的key'}  # 高德地图API 获取Key\n",
    "parameters.update( {'keywords': '植物园',\n",
    "                    'city':     '440000',\n",
    "                    'citylimit': True\n",
    "                   } )\n",
    "\n",
    "pois = []   # 建构最终结果列表pois\n",
    "pg_no = 1   # 建构pg_no，每次给不一样的可选参数page值\n",
    "\n",
    "while True: # 不断迭代，直到 break跳出\n",
    "    parameters.update({'page':pg_no})  #建构可选参数page值 为 pg_no\n",
    "\n",
    "    r = requests.get (\"http://restapi.amap.com/v3/place/text\", params=parameters)\n",
    "    data = r.json()\n",
    "\n",
    "    pois.extend(data['pois'])         # 使用Python列表之extend方法，把返回数据中的结果data['pois']存入pois\n",
    "\n",
    "    \n",
    "    no_pois_this_search = len(pois)   # 计算 累积实质结果数\n",
    "    no_pois = int(data['count'])      # 计算 应有的实质数量\n",
    "\n",
    "\n",
    "    if (no_pois_this_search >= no_pois):  # 若 累积实质结果数 >= 应有的实质数量\n",
    "        break                                   # 则结束迭代跳出\n",
    "    else:\n",
    "        pg_no +=1                               # 否则找下一页数据，把 pg_no增1\n",
    "\n",
    "        \n",
    "# 使用pandas 模块处理数据\n",
    "df_input = pd.DataFrame(pois)\n",
    "        \n",
    "# 选择部份栏位准备输出\n",
    "select_fields = \"location\taddress\tadname\tcityname\tid\timportance\tname\tpname\ttel\ttype\ttypecode\".split(\"\\t\")\n",
    "df = df_input[select_fields]\n",
    "\n",
    "# 经纬度 增加新栏位字段\n",
    "df = df.assign( 经 = [x.split(',')[0] for x in df['location']])\n",
    "df = df.assign( 纬 = [x.split(',')[1] for x in df['location']])\n",
    "\n",
    "# 使用pandas 模块 输出\n",
    "df.to_csv(\"amap_data_for_visualization.tsv\", encoding=\"utf8\", sep='\\t') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>location</th>\n",
       "      <th>address</th>\n",
       "      <th>adname</th>\n",
       "      <th>cityname</th>\n",
       "      <th>id</th>\n",
       "      <th>importance</th>\n",
       "      <th>name</th>\n",
       "      <th>pname</th>\n",
       "      <th>tel</th>\n",
       "      <th>type</th>\n",
       "      <th>typecode</th>\n",
       "      <th>经</th>\n",
       "      <th>纬</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>113.367196,23.181797</td>\n",
       "      <td>天源路1190号</td>\n",
       "      <td>天河区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00140UEO5</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-85231993;020-85232037</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.367196</td>\n",
       "      <td>113.367196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>114.174956,22.578596</td>\n",
       "      <td>仙湖路160号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F37T4NJ</td>\n",
       "      <td>[]</td>\n",
       "      <td>深圳仙湖植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0755-25738430;0755-25722184</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.174956</td>\n",
       "      <td>114.174956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>113.52128,22.29402</td>\n",
       "      <td>健民路328号</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B02F4000E1</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0756-8535999;0756-8535888</td>\n",
       "      <td>风景名胜;风景名胜;国家级景点</td>\n",
       "      <td>110202</td>\n",
       "      <td>113.52128</td>\n",
       "      <td>113.52128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>110.275886,21.168908</td>\n",
       "      <td>湖秀新村1号(近湖光岩)</td>\n",
       "      <td>麻章区</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F701056</td>\n",
       "      <td>[]</td>\n",
       "      <td>南亚热带植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0759-2859145;12301</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.275886</td>\n",
       "      <td>110.275886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>113.620092,22.628194</td>\n",
       "      <td>新港大道</td>\n",
       "      <td>南沙区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00140UFWZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>百万葵园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-84956360;020-83309917;020-84956863</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>113.620092</td>\n",
       "      <td>113.620092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>113.900516,22.500264</td>\n",
       "      <td>月亮湾青青路1号</td>\n",
       "      <td>南山区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F30242B</td>\n",
       "      <td>[]</td>\n",
       "      <td>月亮湾公园-青青世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0755-26403988;0755-26646988;0755-26737330</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.900516</td>\n",
       "      <td>113.900516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>113.770048,22.726385</td>\n",
       "      <td>和二一路32号</td>\n",
       "      <td>宝安区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F37VJA4</td>\n",
       "      <td>[]</td>\n",
       "      <td>海上田园-趣味植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.770048</td>\n",
       "      <td>113.770048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>116.756359,23.502012</td>\n",
       "      <td>广益街道官湖开发区</td>\n",
       "      <td>澄海区</td>\n",
       "      <td>汕头市</td>\n",
       "      <td>B02F2008RH</td>\n",
       "      <td>[]</td>\n",
       "      <td>科隆千树园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0754-85858327;0754-86985976</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>116.756359</td>\n",
       "      <td>116.756359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>110.389479,21.251218</td>\n",
       "      <td>体育南路近体育馆</td>\n",
       "      <td>赤坎区</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F70NY85</td>\n",
       "      <td>[]</td>\n",
       "      <td>南国热带花园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0759-3480019</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>110.389479</td>\n",
       "      <td>110.389479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>110.409452,21.243933</td>\n",
       "      <td>海湾大桥旁</td>\n",
       "      <td>赤坎区</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F701S9V</td>\n",
       "      <td>[]</td>\n",
       "      <td>中澳友谊花园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>110.409452</td>\n",
       "      <td>110.409452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>113.583777,23.623854</td>\n",
       "      <td>城郊街西和村</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141ICC6</td>\n",
       "      <td>[]</td>\n",
       "      <td>宝趣玫瑰世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-87907777</td>\n",
       "      <td>风景名胜;风景名胜;省级景点</td>\n",
       "      <td>110203</td>\n",
       "      <td>113.583777</td>\n",
       "      <td>113.583777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>113.199458,22.654432</td>\n",
       "      <td>古镇海洲东岸北路396号</td>\n",
       "      <td>中山市</td>\n",
       "      <td>中山市</td>\n",
       "      <td>B02F80OWVE</td>\n",
       "      <td>[]</td>\n",
       "      <td>南方绿博园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.199458</td>\n",
       "      <td>113.199458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>110.906533,21.455614</td>\n",
       "      <td>325国道旁</td>\n",
       "      <td>电白区</td>\n",
       "      <td>茂名市</td>\n",
       "      <td>B029C026TX</td>\n",
       "      <td>[]</td>\n",
       "      <td>茂名市珍稀植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0668-2699020</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.906533</td>\n",
       "      <td>110.906533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>114.147043,22.563770</td>\n",
       "      <td>东湖公园</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38I7NS</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-杜鹃园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>114.147043</td>\n",
       "      <td>114.147043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>113.480887,22.539581</td>\n",
       "      <td>逸仙路君华新城附近</td>\n",
       "      <td>中山市</td>\n",
       "      <td>中山市</td>\n",
       "      <td>B02F80OXEE</td>\n",
       "      <td>[]</td>\n",
       "      <td>华佗山公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>113.480887</td>\n",
       "      <td>113.480887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>110.140605,20.382517</td>\n",
       "      <td>G15沈海高速出口</td>\n",
       "      <td>徐闻县</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F701R7Y</td>\n",
       "      <td>[]</td>\n",
       "      <td>中国科学院华南植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.140605</td>\n",
       "      <td>110.140605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>113.819593,24.960177</td>\n",
       "      <td>323国道附近</td>\n",
       "      <td>仁化县</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>B02EF0IAI5</td>\n",
       "      <td>[]</td>\n",
       "      <td>丹霞山灵溪河森林公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0751-6977261;0751-6291683</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.819593</td>\n",
       "      <td>113.819593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>113.26085,23.464305</td>\n",
       "      <td>花山镇铁山村</td>\n",
       "      <td>花都区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141K7U7</td>\n",
       "      <td>[]</td>\n",
       "      <td>香草世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-66609112;020-66609118</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "      <td>113.26085</td>\n",
       "      <td>113.26085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>113.036400,22.549087</td>\n",
       "      <td>新会劳动大学附近</td>\n",
       "      <td>新会区</td>\n",
       "      <td>江门市</td>\n",
       "      <td>B02EE01Q23</td>\n",
       "      <td>[]</td>\n",
       "      <td>圭峰山风景名胜区-圭峰植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.036400</td>\n",
       "      <td>113.036400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>113.256478,23.267326</td>\n",
       "      <td>马岗岭街67号</td>\n",
       "      <td>白云区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141JAZ8</td>\n",
       "      <td>[]</td>\n",
       "      <td>石马桃花公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.256478</td>\n",
       "      <td>113.256478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>110.273411,21.567004</td>\n",
       "      <td>287省道</td>\n",
       "      <td>廉江市</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F7026HL</td>\n",
       "      <td>[]</td>\n",
       "      <td>廉江植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.273411</td>\n",
       "      <td>110.273411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>113.747687,22.967355</td>\n",
       "      <td>绿色路99号</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>B0FFFBDUBN</td>\n",
       "      <td>[]</td>\n",
       "      <td>东莞植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0769-22985736;0769-27380708</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.747687</td>\n",
       "      <td>113.747687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>114.007608,22.962757</td>\n",
       "      <td>翠珠路东200米</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>B0FFHHHXX6</td>\n",
       "      <td>[]</td>\n",
       "      <td>常平农业科普园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>114.007608</td>\n",
       "      <td>114.007608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>112.877754,23.188254</td>\n",
       "      <td>南湖路与森林大道交叉口北100米</td>\n",
       "      <td>三水区</td>\n",
       "      <td>佛山市</td>\n",
       "      <td>B02F503M7E</td>\n",
       "      <td>[]</td>\n",
       "      <td>三水森林公园-孔圣园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0757-87821060;0757-87820806</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>112.877754</td>\n",
       "      <td>112.877754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>114.150001,22.565604</td>\n",
       "      <td>东湖二路21号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY0F</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-观赏花木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.150001</td>\n",
       "      <td>114.150001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>114.147004,22.557208</td>\n",
       "      <td>沿河北路布心路出口附近</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY09</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-棕榈园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.147004</td>\n",
       "      <td>114.147004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>114.148105,22.563978</td>\n",
       "      <td>东湖二路12号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY04</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-树木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.148105</td>\n",
       "      <td>114.148105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>114.150001,22.565105</td>\n",
       "      <td>东湖二路附近</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OXXP</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-古树区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.150001</td>\n",
       "      <td>114.150001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>113.369492,22.4894</td>\n",
       "      <td>南环路与永安一路交汇处</td>\n",
       "      <td>中山市</td>\n",
       "      <td>中山市</td>\n",
       "      <td>B02F80P8XC</td>\n",
       "      <td>[]</td>\n",
       "      <td>中山市树木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0760-89886985</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.369492</td>\n",
       "      <td>113.369492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>113.672178,24.805628</td>\n",
       "      <td>新韶镇东山村</td>\n",
       "      <td>浈江区</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>B0FFF00PVD</td>\n",
       "      <td>[]</td>\n",
       "      <td>韶关樱花公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>113.672178</td>\n",
       "      <td>113.672178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>111.881159,21.635098</td>\n",
       "      <td>麻礼沙村山海经花海</td>\n",
       "      <td>江城区</td>\n",
       "      <td>阳江市</td>\n",
       "      <td>B0FFGH195I</td>\n",
       "      <td>[]</td>\n",
       "      <td>山海经农业大观园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0662-3855388</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "      <td>111.881159</td>\n",
       "      <td>111.881159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>113.489325,22.960797</td>\n",
       "      <td>东环路与长江路交叉口东南100米</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFHRW1CG</td>\n",
       "      <td>[]</td>\n",
       "      <td>萌萌多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.489325</td>\n",
       "      <td>113.489325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>114.008157,22.540220</td>\n",
       "      <td>侨城东路深南大道8002号深圳国际园林花卉博览园内</td>\n",
       "      <td>福田区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38SQZQ</td>\n",
       "      <td>[]</td>\n",
       "      <td>深圳国际园林花卉博览园-滙芳园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "      <td>114.008157</td>\n",
       "      <td>114.008157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>115.345690,22.864822</td>\n",
       "      <td>242省道西50米</td>\n",
       "      <td>城区</td>\n",
       "      <td>汕尾市</td>\n",
       "      <td>B0FFG7SL6H</td>\n",
       "      <td>[]</td>\n",
       "      <td>鸿园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>115.345690</td>\n",
       "      <td>115.345690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>113.299970,23.134819</td>\n",
       "      <td>环市东路465号西座</td>\n",
       "      <td>越秀区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFGSJ62C</td>\n",
       "      <td>[]</td>\n",
       "      <td>啊咪要出去玩了</td>\n",
       "      <td>广东省</td>\n",
       "      <td>18819456794</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.299970</td>\n",
       "      <td>113.299970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>113.521401,22.291602</td>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B0FFG2CYJP</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观-蝴蝶兰生产区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.521401</td>\n",
       "      <td>113.521401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>114.227049,22.635539</td>\n",
       "      <td>横岗安良安兴路64号</td>\n",
       "      <td>龙岗区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B0FFGJMI4P</td>\n",
       "      <td>[]</td>\n",
       "      <td>慕兰萃植物养肤馆</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.227049</td>\n",
       "      <td>114.227049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>113.359600,23.037920</td>\n",
       "      <td>小谷围街道广东科学中心</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFH0CZHP</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东科学中心-岭南佳果园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.359600</td>\n",
       "      <td>113.359600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>113.385399,22.929552</td>\n",
       "      <td>东兴路306号</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFHC9SZN</td>\n",
       "      <td>[]</td>\n",
       "      <td>肉嘟嘟多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>15820272570</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.385399</td>\n",
       "      <td>113.385399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>113.406543,23.035617</td>\n",
       "      <td>大学城中八路西200米</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFG0FIGG</td>\n",
       "      <td>[]</td>\n",
       "      <td>岭南印象园-乡居田园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.406543</td>\n",
       "      <td>113.406543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>113.264053,23.260056</td>\n",
       "      <td>[]</td>\n",
       "      <td>白云区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFIJYK5I</td>\n",
       "      <td>[]</td>\n",
       "      <td>石马桃花种植场</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.264053</td>\n",
       "      <td>113.264053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>114.028122,24.047526</td>\n",
       "      <td>S347(瑜家农庄旁)</td>\n",
       "      <td>新丰县</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>B0FFH5L8K9</td>\n",
       "      <td>[]</td>\n",
       "      <td>潘家寨原生态农业观光园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.028122</td>\n",
       "      <td>114.028122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>113.592358,23.627597</td>\n",
       "      <td>城郊街西和村1队</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141OTQ3</td>\n",
       "      <td>[]</td>\n",
       "      <td>天适樱花悠乐园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-37941188</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.592358</td>\n",
       "      <td>113.592358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>113.191648,23.386573</td>\n",
       "      <td>中华大街与金华路交叉口东南150米</td>\n",
       "      <td>花都区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141IBJF</td>\n",
       "      <td>[]</td>\n",
       "      <td>资政园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.191648</td>\n",
       "      <td>113.191648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>114.078000,22.562707</td>\n",
       "      <td>北环大道1001号</td>\n",
       "      <td>福田区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY0O</td>\n",
       "      <td>[]</td>\n",
       "      <td>笔架山公园-白千层树林</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.078000</td>\n",
       "      <td>114.078000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>113.363991,23.181380</td>\n",
       "      <td>天源路1190号华南植物园世界植物景观温室群景区热带雨林植物室</td>\n",
       "      <td>天河区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFFXETSP</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南植物园-河谷雨林区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.363991</td>\n",
       "      <td>113.363991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>111.026469,21.463283</td>\n",
       "      <td>下里南路东50米</td>\n",
       "      <td>电白区</td>\n",
       "      <td>茂名市</td>\n",
       "      <td>B0FFH3Z593</td>\n",
       "      <td>[]</td>\n",
       "      <td>九珠教学示范园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>111.026469</td>\n",
       "      <td>111.026469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>110.851024,21.432936</td>\n",
       "      <td>广湛公路南50米</td>\n",
       "      <td>吴川市</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F700SW3</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南农科园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.851024</td>\n",
       "      <td>110.851024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>116.410734,23.348306</td>\n",
       "      <td>谷饶镇华里乡</td>\n",
       "      <td>潮阳区</td>\n",
       "      <td>汕头市</td>\n",
       "      <td>B0FFFABVSG</td>\n",
       "      <td>[]</td>\n",
       "      <td>雅香植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>116.410734</td>\n",
       "      <td>116.410734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>113.484751,22.904370</td>\n",
       "      <td>清流村十七队观龙岛</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFHDKCF6</td>\n",
       "      <td>[]</td>\n",
       "      <td>胧月多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.484751</td>\n",
       "      <td>113.484751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>114.279906,22.638547</td>\n",
       "      <td>东部华侨城</td>\n",
       "      <td>盐田区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B0FFFDOJ09</td>\n",
       "      <td>[]</td>\n",
       "      <td>东部华侨城-三洲茶园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>114.279906</td>\n",
       "      <td>114.279906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>114.146000,22.563602</td>\n",
       "      <td>爱国路</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY0G</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-花圃</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.146000</td>\n",
       "      <td>114.146000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>113.366521,23.187930</td>\n",
       "      <td>天源路1190号华南植物园内</td>\n",
       "      <td>天河区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141U8UM</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南植物园-孑遗植物区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.366521</td>\n",
       "      <td>113.366521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>114.001425,23.803479</td>\n",
       "      <td>[]</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFI7869U</td>\n",
       "      <td>[]</td>\n",
       "      <td>桂峰石斛博览园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.001425</td>\n",
       "      <td>114.001425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>113.361881,23.037000</td>\n",
       "      <td>科普路168号</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFG1RB78</td>\n",
       "      <td>[]</td>\n",
       "      <td>珍稀濒危植物</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.361881</td>\n",
       "      <td>113.361881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>113.520411,22.290238</td>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B0FFF2CMPZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观-树状作物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.520411</td>\n",
       "      <td>113.520411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>113.621186,22.629145</td>\n",
       "      <td>万顷沙镇新垦15涌半百万葵园内</td>\n",
       "      <td>南沙区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFFF6B90</td>\n",
       "      <td>[]</td>\n",
       "      <td>百万葵园-薰衣草伊甸园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.621186</td>\n",
       "      <td>113.621186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>113.521023,22.292135</td>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B0FFF2WB6C</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观-沙漠植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.521023</td>\n",
       "      <td>113.521023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>113.295619,23.094005</td>\n",
       "      <td>新港西路135号中山大学南校区</td>\n",
       "      <td>海珠区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFFDBSP6</td>\n",
       "      <td>[]</td>\n",
       "      <td>中山大学广州南校区竹种标本园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.295619</td>\n",
       "      <td>113.295619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>111.777369,22.743343</td>\n",
       "      <td>324国道南50米</td>\n",
       "      <td>罗定市</td>\n",
       "      <td>云浮市</td>\n",
       "      <td>B0FFGAHVMI</td>\n",
       "      <td>[]</td>\n",
       "      <td>罗定市海惠生态农业观光示范园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>111.777369</td>\n",
       "      <td>111.777369</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>193 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 location                          address adname cityname  \\\n",
       "0    113.367196,23.181797                         天源路1190号    天河区      广州市   \n",
       "1    114.174956,22.578596                          仙湖路160号    罗湖区      深圳市   \n",
       "2      113.52128,22.29402                          健民路328号    香洲区      珠海市   \n",
       "3    110.275886,21.168908                     湖秀新村1号(近湖光岩)    麻章区      湛江市   \n",
       "4    113.620092,22.628194                             新港大道    南沙区      广州市   \n",
       "5    113.900516,22.500264                         月亮湾青青路1号    南山区      深圳市   \n",
       "6    113.770048,22.726385                          和二一路32号    宝安区      深圳市   \n",
       "7    116.756359,23.502012                        广益街道官湖开发区    澄海区      汕头市   \n",
       "8    110.389479,21.251218                         体育南路近体育馆    赤坎区      湛江市   \n",
       "9    110.409452,21.243933                            海湾大桥旁    赤坎区      湛江市   \n",
       "10   113.583777,23.623854                           城郊街西和村    从化区      广州市   \n",
       "11   113.199458,22.654432                     古镇海洲东岸北路396号    中山市      中山市   \n",
       "12   110.906533,21.455614                           325国道旁    电白区      茂名市   \n",
       "13   114.147043,22.563770                             东湖公园    罗湖区      深圳市   \n",
       "14   113.480887,22.539581                        逸仙路君华新城附近    中山市      中山市   \n",
       "15   110.140605,20.382517                        G15沈海高速出口    徐闻县      湛江市   \n",
       "16   113.819593,24.960177                          323国道附近    仁化县      韶关市   \n",
       "17    113.26085,23.464305                           花山镇铁山村    花都区      广州市   \n",
       "18   113.036400,22.549087                         新会劳动大学附近    新会区      江门市   \n",
       "19   113.256478,23.267326                          马岗岭街67号    白云区      广州市   \n",
       "20   110.273411,21.567004                            287省道    廉江市      湛江市   \n",
       "21   113.747687,22.967355                           绿色路99号    东莞市      东莞市   \n",
       "22   114.007608,22.962757                         翠珠路东200米    东莞市      东莞市   \n",
       "23   112.877754,23.188254                 南湖路与森林大道交叉口北100米    三水区      佛山市   \n",
       "24   114.150001,22.565604                          东湖二路21号    罗湖区      深圳市   \n",
       "25   114.147004,22.557208                      沿河北路布心路出口附近    罗湖区      深圳市   \n",
       "26   114.148105,22.563978                          东湖二路12号    罗湖区      深圳市   \n",
       "27   114.150001,22.565105                           东湖二路附近    罗湖区      深圳市   \n",
       "28     113.369492,22.4894                      南环路与永安一路交汇处    中山市      中山市   \n",
       "29   113.672178,24.805628                           新韶镇东山村    浈江区      韶关市   \n",
       "..                    ...                              ...    ...      ...   \n",
       "163  111.881159,21.635098                        麻礼沙村山海经花海    江城区      阳江市   \n",
       "164  113.489325,22.960797                 东环路与长江路交叉口东南100米    番禺区      广州市   \n",
       "165  114.008157,22.540220        侨城东路深南大道8002号深圳国际园林花卉博览园内    福田区      深圳市   \n",
       "166  115.345690,22.864822                        242省道西50米     城区      汕尾市   \n",
       "167  113.299970,23.134819                       环市东路465号西座    越秀区      广州市   \n",
       "168  113.521401,22.291602                    旅游路2428号农科奇观内    香洲区      珠海市   \n",
       "169  114.227049,22.635539                       横岗安良安兴路64号    龙岗区      深圳市   \n",
       "170  113.359600,23.037920                      小谷围街道广东科学中心    番禺区      广州市   \n",
       "171  113.385399,22.929552                          东兴路306号    番禺区      广州市   \n",
       "172  113.406543,23.035617                      大学城中八路西200米    番禺区      广州市   \n",
       "173  113.264053,23.260056                               []    白云区      广州市   \n",
       "174  114.028122,24.047526                      S347(瑜家农庄旁)    新丰县      韶关市   \n",
       "175  113.592358,23.627597                         城郊街西和村1队    从化区      广州市   \n",
       "176  113.191648,23.386573                中华大街与金华路交叉口东南150米    花都区      广州市   \n",
       "177  114.078000,22.562707                        北环大道1001号    福田区      深圳市   \n",
       "178  113.363991,23.181380  天源路1190号华南植物园世界植物景观温室群景区热带雨林植物室    天河区      广州市   \n",
       "179  111.026469,21.463283                         下里南路东50米    电白区      茂名市   \n",
       "180  110.851024,21.432936                         广湛公路南50米    吴川市      湛江市   \n",
       "181  116.410734,23.348306                           谷饶镇华里乡    潮阳区      汕头市   \n",
       "182  113.484751,22.904370                        清流村十七队观龙岛    番禺区      广州市   \n",
       "183  114.279906,22.638547                            东部华侨城    盐田区      深圳市   \n",
       "184  114.146000,22.563602                              爱国路    罗湖区      深圳市   \n",
       "185  113.366521,23.187930                   天源路1190号华南植物园内    天河区      广州市   \n",
       "186  114.001425,23.803479                               []    从化区      广州市   \n",
       "187  113.361881,23.037000                          科普路168号    番禺区      广州市   \n",
       "188  113.520411,22.290238                    旅游路2428号农科奇观内    香洲区      珠海市   \n",
       "189  113.621186,22.629145                  万顷沙镇新垦15涌半百万葵园内    南沙区      广州市   \n",
       "190  113.521023,22.292135                    旅游路2428号农科奇观内    香洲区      珠海市   \n",
       "191  113.295619,23.094005                  新港西路135号中山大学南校区    海珠区      广州市   \n",
       "192  111.777369,22.743343                        324国道南50米    罗定市      云浮市   \n",
       "\n",
       "             id importance             name pname  \\\n",
       "0    B00140UEO5         []            华南植物园   广东省   \n",
       "1    B02F37T4NJ         []          深圳仙湖植物园   广东省   \n",
       "2    B02F4000E1         []             农科奇观   广东省   \n",
       "3    B02F701056         []          南亚热带植物园   广东省   \n",
       "4    B00140UFWZ         []             百万葵园   广东省   \n",
       "5    B02F30242B         []       月亮湾公园-青青世界   广东省   \n",
       "6    B02F37VJA4         []       海上田园-趣味植物园   广东省   \n",
       "7    B02F2008RH         []            科隆千树园   广东省   \n",
       "8    B02F70NY85         []           南国热带花园   广东省   \n",
       "9    B02F701S9V         []           中澳友谊花园   广东省   \n",
       "10   B00141ICC6         []           宝趣玫瑰世界   广东省   \n",
       "11   B02F80OWVE         []            南方绿博园   广东省   \n",
       "12   B029C026TX         []         茂名市珍稀植物园   广东省   \n",
       "13   B02F38I7NS         []         东湖公园-杜鹃园   广东省   \n",
       "14   B02F80OXEE         []            华佗山公园   广东省   \n",
       "15   B02F701R7Y         []       中国科学院华南植物园   广东省   \n",
       "16   B02EF0IAI5         []       丹霞山灵溪河森林公园   广东省   \n",
       "17   B00141K7U7         []             香草世界   广东省   \n",
       "18   B02EE01Q23         []   圭峰山风景名胜区-圭峰植物园   广东省   \n",
       "19   B00141JAZ8         []           石马桃花公园   广东省   \n",
       "20   B02F7026HL         []            廉江植物园   广东省   \n",
       "21   B0FFFBDUBN         []            东莞植物园   广东省   \n",
       "22   B0FFHHHXX6         []          常平农业科普园   广东省   \n",
       "23   B02F503M7E         []       三水森林公园-孔圣园   广东省   \n",
       "24   B02F38OY0F         []       东湖公园-观赏花木园   广东省   \n",
       "25   B02F38OY09         []         东湖公园-棕榈园   广东省   \n",
       "26   B02F38OY04         []         东湖公园-树木园   广东省   \n",
       "27   B02F38OXXP         []         东湖公园-古树区   广东省   \n",
       "28   B02F80P8XC         []           中山市树木园   广东省   \n",
       "29   B0FFF00PVD         []           韶关樱花公园   广东省   \n",
       "..          ...        ...              ...   ...   \n",
       "163  B0FFGH195I         []         山海经农业大观园   广东省   \n",
       "164  B0FFHRW1CG         []          萌萌多肉植物园   广东省   \n",
       "165  B02F38SQZQ         []  深圳国际园林花卉博览园-滙芳园   广东省   \n",
       "166  B0FFG7SL6H         []               鸿园   广东省   \n",
       "167  B0FFGSJ62C         []          啊咪要出去玩了   广东省   \n",
       "168  B0FFG2CYJP         []      农科奇观-蝴蝶兰生产区   广东省   \n",
       "169  B0FFGJMI4P         []         慕兰萃植物养肤馆   广东省   \n",
       "170  B0FFH0CZHP         []     广东科学中心-岭南佳果园   广东省   \n",
       "171  B0FFHC9SZN         []         肉嘟嘟多肉植物园   广东省   \n",
       "172  B0FFG0FIGG         []       岭南印象园-乡居田园   广东省   \n",
       "173  B0FFIJYK5I         []          石马桃花种植场   广东省   \n",
       "174  B0FFH5L8K9         []      潘家寨原生态农业观光园   广东省   \n",
       "175  B00141OTQ3         []          天适樱花悠乐园   广东省   \n",
       "176  B00141IBJF         []              资政园   广东省   \n",
       "177  B02F38OY0O         []      笔架山公园-白千层树林   广东省   \n",
       "178  B0FFFXETSP         []      华南植物园-河谷雨林区   广东省   \n",
       "179  B0FFH3Z593         []          九珠教学示范园   广东省   \n",
       "180  B02F700SW3         []            华南农科园   广东省   \n",
       "181  B0FFFABVSG         []            雅香植物园   广东省   \n",
       "182  B0FFHDKCF6         []          胧月多肉植物园   广东省   \n",
       "183  B0FFFDOJ09         []       东部华侨城-三洲茶园   广东省   \n",
       "184  B02F38OY0G         []          东湖公园-花圃   广东省   \n",
       "185  B00141U8UM         []      华南植物园-孑遗植物区   广东省   \n",
       "186  B0FFI7869U         []          桂峰石斛博览园   广东省   \n",
       "187  B0FFG1RB78         []           珍稀濒危植物   广东省   \n",
       "188  B0FFF2CMPZ         []       农科奇观-树状作物园   广东省   \n",
       "189  B0FFFF6B90         []      百万葵园-薰衣草伊甸园   广东省   \n",
       "190  B0FFF2WB6C         []       农科奇观-沙漠植物园   广东省   \n",
       "191  B0FFFDBSP6         []   中山大学广州南校区竹种标本园   广东省   \n",
       "192  B0FFGAHVMI         []   罗定市海惠生态农业观光示范园   广东省   \n",
       "\n",
       "                                           tel              type typecode  \\\n",
       "0                    020-85231993;020-85232037     风景名胜;公园广场;植物园   110103   \n",
       "1                  0755-25738430;0755-25722184     风景名胜;公园广场;植物园   110103   \n",
       "2                    0756-8535999;0756-8535888   风景名胜;风景名胜;国家级景点   110202   \n",
       "3                           0759-2859145;12301     风景名胜;公园广场;植物园   110103   \n",
       "4       020-84956360;020-83309917;020-84956863      风景名胜;公园广场;公园   110101   \n",
       "5    0755-26403988;0755-26646988;0755-26737330    风景名胜;风景名胜;风景名胜   110200   \n",
       "6                                           []    风景名胜;风景名胜;风景名胜   110200   \n",
       "7                  0754-85858327;0754-86985976     风景名胜;公园广场;植物园   110103   \n",
       "8                                 0759-3480019      风景名胜;公园广场;公园   110101   \n",
       "9                                           []      风景名胜;公园广场;公园   110101   \n",
       "10                                020-87907777    风景名胜;风景名胜;省级景点   110203   \n",
       "11                                          []    风景名胜;风景名胜;风景名胜   110200   \n",
       "12                                0668-2699020     风景名胜;公园广场;植物园   110103   \n",
       "13                                          []      风景名胜;公园广场;公园   110101   \n",
       "14                                          []      风景名胜;公园广场;公园   110101   \n",
       "15                                          []     风景名胜;公园广场;植物园   110103   \n",
       "16                   0751-6977261;0751-6291683    风景名胜;风景名胜;风景名胜   110200   \n",
       "17                   020-66609112;020-66609118  风景名胜;风景名胜相关;旅游景点   110000   \n",
       "18                                          []     风景名胜;公园广场;植物园   110103   \n",
       "19                                          []     风景名胜;公园广场;植物园   110103   \n",
       "20                                          []     风景名胜;公园广场;植物园   110103   \n",
       "21                 0769-22985736;0769-27380708     风景名胜;公园广场;植物园   110103   \n",
       "22                                          []      风景名胜;公园广场;公园   110101   \n",
       "23                 0757-87821060;0757-87820806    风景名胜;风景名胜;风景名胜   110200   \n",
       "24                                          []     风景名胜;公园广场;植物园   110103   \n",
       "25                                          []     风景名胜;公园广场;植物园   110103   \n",
       "26                                          []     风景名胜;公园广场;植物园   110103   \n",
       "27                                          []     风景名胜;公园广场;植物园   110103   \n",
       "28                               0760-89886985     风景名胜;公园广场;植物园   110103   \n",
       "29                                          []      风景名胜;公园广场;公园   110101   \n",
       "..                                         ...               ...      ...   \n",
       "163                               0662-3855388  风景名胜;风景名胜相关;旅游景点   110000   \n",
       "164                                         []     风景名胜;公园广场;植物园   110103   \n",
       "165                                         []  风景名胜;风景名胜相关;旅游景点   110000   \n",
       "166                                         []     风景名胜;公园广场;植物园   110103   \n",
       "167                                18819456794     风景名胜;公园广场;植物园   110103   \n",
       "168                                         []     风景名胜;公园广场;植物园   110103   \n",
       "169                                         []     风景名胜;公园广场;植物园   110103   \n",
       "170                                         []     风景名胜;公园广场;植物园   110103   \n",
       "171                                15820272570     风景名胜;公园广场;植物园   110103   \n",
       "172                                         []    风景名胜;风景名胜;风景名胜   110200   \n",
       "173                                         []     风景名胜;公园广场;植物园   110103   \n",
       "174                                         []     风景名胜;公园广场;植物园   110103   \n",
       "175                               020-37941188    风景名胜;风景名胜;风景名胜   110200   \n",
       "176                                         []     风景名胜;公园广场;植物园   110103   \n",
       "177                                         []     风景名胜;公园广场;植物园   110103   \n",
       "178                                         []     风景名胜;公园广场;植物园   110103   \n",
       "179                                         []     风景名胜;公园广场;植物园   110103   \n",
       "180                                         []     风景名胜;公园广场;植物园   110103   \n",
       "181                                         []     风景名胜;公园广场;植物园   110103   \n",
       "182                                         []     风景名胜;公园广场;植物园   110103   \n",
       "183                                         []    风景名胜;风景名胜;风景名胜   110200   \n",
       "184                                         []     风景名胜;公园广场;植物园   110103   \n",
       "185                                         []    风景名胜;风景名胜;风景名胜   110200   \n",
       "186                                         []     风景名胜;公园广场;植物园   110103   \n",
       "187                                         []     风景名胜;公园广场;植物园   110103   \n",
       "188                                         []     风景名胜;公园广场;植物园   110103   \n",
       "189                                         []     风景名胜;公园广场;植物园   110103   \n",
       "190                                         []     风景名胜;公园广场;植物园   110103   \n",
       "191                                         []     风景名胜;公园广场;植物园   110103   \n",
       "192                                         []     风景名胜;公园广场;植物园   110103   \n",
       "\n",
       "              经           纬  \n",
       "0    113.367196  113.367196  \n",
       "1    114.174956  114.174956  \n",
       "2     113.52128   113.52128  \n",
       "3    110.275886  110.275886  \n",
       "4    113.620092  113.620092  \n",
       "5    113.900516  113.900516  \n",
       "6    113.770048  113.770048  \n",
       "7    116.756359  116.756359  \n",
       "8    110.389479  110.389479  \n",
       "9    110.409452  110.409452  \n",
       "10   113.583777  113.583777  \n",
       "11   113.199458  113.199458  \n",
       "12   110.906533  110.906533  \n",
       "13   114.147043  114.147043  \n",
       "14   113.480887  113.480887  \n",
       "15   110.140605  110.140605  \n",
       "16   113.819593  113.819593  \n",
       "17    113.26085   113.26085  \n",
       "18   113.036400  113.036400  \n",
       "19   113.256478  113.256478  \n",
       "20   110.273411  110.273411  \n",
       "21   113.747687  113.747687  \n",
       "22   114.007608  114.007608  \n",
       "23   112.877754  112.877754  \n",
       "24   114.150001  114.150001  \n",
       "25   114.147004  114.147004  \n",
       "26   114.148105  114.148105  \n",
       "27   114.150001  114.150001  \n",
       "28   113.369492  113.369492  \n",
       "29   113.672178  113.672178  \n",
       "..          ...         ...  \n",
       "163  111.881159  111.881159  \n",
       "164  113.489325  113.489325  \n",
       "165  114.008157  114.008157  \n",
       "166  115.345690  115.345690  \n",
       "167  113.299970  113.299970  \n",
       "168  113.521401  113.521401  \n",
       "169  114.227049  114.227049  \n",
       "170  113.359600  113.359600  \n",
       "171  113.385399  113.385399  \n",
       "172  113.406543  113.406543  \n",
       "173  113.264053  113.264053  \n",
       "174  114.028122  114.028122  \n",
       "175  113.592358  113.592358  \n",
       "176  113.191648  113.191648  \n",
       "177  114.078000  114.078000  \n",
       "178  113.363991  113.363991  \n",
       "179  111.026469  111.026469  \n",
       "180  110.851024  110.851024  \n",
       "181  116.410734  116.410734  \n",
       "182  113.484751  113.484751  \n",
       "183  114.279906  114.279906  \n",
       "184  114.146000  114.146000  \n",
       "185  113.366521  113.366521  \n",
       "186  114.001425  114.001425  \n",
       "187  113.361881  113.361881  \n",
       "188  113.520411  113.520411  \n",
       "189  113.621186  113.621186  \n",
       "190  113.521023  113.521023  \n",
       "191  113.295619  113.295619  \n",
       "192  111.777369  111.777369  \n",
       "\n",
       "[193 rows x 13 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
